<?php
require("Sajax.php");
include ('common/connection.php');
$queryUser="SELECT count(*) FROM `users`";
$resultUser=mysql_db_query($db_name,$queryUser);
$rsUser=mysql_fetch_array($resultUser);

$qsSP="SELECT count(*) FROM `users` where spouse=1";
$resSP=mysql_db_query($db_name,$qsSP);
$rsSP=mysql_fetch_array($resSP);

$qsLM="SELECT count(*) FROM `users` where regis_option=1";
$resLM=mysql_db_query($db_name,$qsLM);
$rsLM=mysql_fetch_array($resLM);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>::.Registration Summary.::</title>
<link rel="stylesheet" href="style/style.css" type="text/css" />
<p> 
<table width="200" border="2" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" align="center">
  <tr>
  <td align="right" class="commenttext" width="70%">
  <b>No. Of Registration &nbsp; </b></td>
    <td align="center" class="formhead"><font size="5"><?php $origi=$rsUser[0]-1; echo $total=($origi);?></font></td>
  </tr>
  <tr>
  <td align="right" class="commenttext" width="70%">
  <b>No. Of Life Members &nbsp; </b></td>
    <td align="center" class="formhead"><font size="5"><?php echo $rsLM[0];?></font></td>
  </tr>
  <tr>
  <td align="right" class="commenttext" width="30%">
  <b>No. Of Spouse  &nbsp;</b></td>
    <td align="center" class="formhead"><font size="5"><?php $nsp=$rsSP[0]; echo $total=($nsp);?></font></td>
  </tr>
  <tr>
  <td align="right" class="commenttext" width="30%">
  <b>Total Participant  &nbsp;</b></td>
    <td align="center" class="formhead"><font size="5"><?php echo $total=($nsp+$origi);?></font></td>
  </tr>
</table>
</p>
</body>
</html>
